package com.hzf.material.dao.model;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;

public class MaterialShopExample implements Serializable {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private static final long serialVersionUID = 1L;

    public MaterialShopExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria implements Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andShopIdIsNull() {
            addCriterion("a.shop_id is null");
            return (Criteria) this;
        }

        public Criteria andShopIdIsNotNull() {
            addCriterion("a.shop_id is not null");
            return (Criteria) this;
        }

        public Criteria andShopIdEqualTo(Integer value) {
            addCriterion("a.shop_id =", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotEqualTo(Integer value) {
            addCriterion("a.shop_id <>", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThan(Integer value) {
            addCriterion("a.shop_id >", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("a.shop_id >=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThan(Integer value) {
            addCriterion("a.shop_id <", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThanOrEqualTo(Integer value) {
            addCriterion("a.shop_id <=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdIn(List<Integer> values) {
            addCriterion("a.shop_id in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotIn(List<Integer> values) {
            addCriterion("a.shop_id not in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdBetween(Integer value1, Integer value2) {
            addCriterion("a.shop_id between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotBetween(Integer value1, Integer value2) {
            addCriterion("a.shop_id not between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNull() {
            addCriterion("a.shop_name is null");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNotNull() {
            addCriterion("a.shop_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopNameEqualTo(String value) {
            addCriterion("a.shop_name =", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotEqualTo(String value) {
            addCriterion("a.shop_name <>", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThan(String value) {
            addCriterion("a.shop_name >", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("a.shop_name >=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThan(String value) {
            addCriterion("a.shop_name <", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThanOrEqualTo(String value) {
            addCriterion("a.shop_name <=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLike(String value) {
            addCriterion("a.shop_name like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotLike(String value) {
            addCriterion("a.shop_name not like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameIn(List<String> values) {
            addCriterion("a.shop_name in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotIn(List<String> values) {
            addCriterion("a.shop_name not in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameBetween(String value1, String value2) {
            addCriterion("a.shop_name between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotBetween(String value1, String value2) {
            addCriterion("a.shop_name not between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andImgUrlIsNull() {
            addCriterion("a.img_url is null");
            return (Criteria) this;
        }

        public Criteria andImgUrlIsNotNull() {
            addCriterion("a.img_url is not null");
            return (Criteria) this;
        }

        public Criteria andImgUrlEqualTo(String value) {
            addCriterion("a.img_url =", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotEqualTo(String value) {
            addCriterion("a.img_url <>", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlGreaterThan(String value) {
            addCriterion("a.img_url >", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlGreaterThanOrEqualTo(String value) {
            addCriterion("a.img_url >=", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlLessThan(String value) {
            addCriterion("a.img_url <", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlLessThanOrEqualTo(String value) {
            addCriterion("a.img_url <=", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlLike(String value) {
            addCriterion("a.img_url like", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotLike(String value) {
            addCriterion("a.img_url not like", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlIn(List<String> values) {
            addCriterion("a.img_url in", values, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotIn(List<String> values) {
            addCriterion("a.img_url not in", values, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlBetween(String value1, String value2) {
            addCriterion("a.img_url between", value1, value2, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotBetween(String value1, String value2) {
            addCriterion("a.img_url not between", value1, value2, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andShopHostNameIsNull() {
            addCriterion("a.shop_host_name is null");
            return (Criteria) this;
        }

        public Criteria andShopHostNameIsNotNull() {
            addCriterion("a.shop_host_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopHostNameEqualTo(String value) {
            addCriterion("a.shop_host_name =", value, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameNotEqualTo(String value) {
            addCriterion("a.shop_host_name <>", value, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameGreaterThan(String value) {
            addCriterion("a.shop_host_name >", value, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameGreaterThanOrEqualTo(String value) {
            addCriterion("a.shop_host_name >=", value, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameLessThan(String value) {
            addCriterion("a.shop_host_name <", value, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameLessThanOrEqualTo(String value) {
            addCriterion("a.shop_host_name <=", value, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameLike(String value) {
            addCriterion("a.shop_host_name like", value, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameNotLike(String value) {
            addCriterion("a.shop_host_name not like", value, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameIn(List<String> values) {
            addCriterion("a.shop_host_name in", values, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameNotIn(List<String> values) {
            addCriterion("a.shop_host_name not in", values, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameBetween(String value1, String value2) {
            addCriterion("a.shop_host_name between", value1, value2, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostNameNotBetween(String value1, String value2) {
            addCriterion("a.shop_host_name not between", value1, value2, "shopHostName");
            return (Criteria) this;
        }

        public Criteria andShopHostTelIsNull() {
            addCriterion("a.shop_host_tel is null");
            return (Criteria) this;
        }

        public Criteria andShopHostTelIsNotNull() {
            addCriterion("a.shop_host_tel is not null");
            return (Criteria) this;
        }

        public Criteria andShopHostTelEqualTo(String value) {
            addCriterion("a.shop_host_tel =", value, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelNotEqualTo(String value) {
            addCriterion("a.shop_host_tel <>", value, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelGreaterThan(String value) {
            addCriterion("a.shop_host_tel >", value, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelGreaterThanOrEqualTo(String value) {
            addCriterion("a.shop_host_tel >=", value, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelLessThan(String value) {
            addCriterion("a.shop_host_tel <", value, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelLessThanOrEqualTo(String value) {
            addCriterion("a.shop_host_tel <=", value, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelLike(String value) {
            addCriterion("a.shop_host_tel like", value, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelNotLike(String value) {
            addCriterion("a.shop_host_tel not like", value, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelIn(List<String> values) {
            addCriterion("a.shop_host_tel in", values, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelNotIn(List<String> values) {
            addCriterion("a.shop_host_tel not in", values, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelBetween(String value1, String value2) {
            addCriterion("a.shop_host_tel between", value1, value2, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andShopHostTelNotBetween(String value1, String value2) {
            addCriterion("a.shop_host_tel not between", value1, value2, "shopHostTel");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("a.city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("a.city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("a.city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("a.city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("a.city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("a.city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("a.city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("a.city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("a.city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("a.city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("a.city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("a.city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("a.city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("a.city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andShopAddressIsNull() {
            addCriterion("a.shop_address is null");
            return (Criteria) this;
        }

        public Criteria andShopAddressIsNotNull() {
            addCriterion("a.shop_address is not null");
            return (Criteria) this;
        }

        public Criteria andShopAddressEqualTo(String value) {
            addCriterion("a.shop_address =", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressNotEqualTo(String value) {
            addCriterion("a.shop_address <>", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressGreaterThan(String value) {
            addCriterion("a.shop_address >", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressGreaterThanOrEqualTo(String value) {
            addCriterion("a.shop_address >=", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressLessThan(String value) {
            addCriterion("a.shop_address <", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressLessThanOrEqualTo(String value) {
            addCriterion("a.shop_address <=", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressLike(String value) {
            addCriterion("a.shop_address like", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressNotLike(String value) {
            addCriterion("a.shop_address not like", value, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressIn(List<String> values) {
            addCriterion("a.shop_address in", values, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressNotIn(List<String> values) {
            addCriterion("a.shop_address not in", values, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressBetween(String value1, String value2) {
            addCriterion("a.shop_address between", value1, value2, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andShopAddressNotBetween(String value1, String value2) {
            addCriterion("a.shop_address not between", value1, value2, "shopAddress");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdIsNull() {
            addCriterion("a.market_type_id is null");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdIsNotNull() {
            addCriterion("a.market_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdEqualTo(Integer value) {
            addCriterion("a.market_type_id =", value, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdNotEqualTo(Integer value) {
            addCriterion("a.market_type_id <>", value, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdGreaterThan(Integer value) {
            addCriterion("a.market_type_id >", value, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("a.market_type_id >=", value, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdLessThan(Integer value) {
            addCriterion("a.market_type_id <", value, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("a.market_type_id <=", value, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdIn(List<Integer> values) {
            addCriterion("a.market_type_id in", values, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdNotIn(List<Integer> values) {
            addCriterion("a.market_type_id not in", values, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("a.market_type_id between", value1, value2, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("a.market_type_id not between", value1, value2, "marketTypeId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdIsNull() {
            addCriterion("a.market_list_id is null");
            return (Criteria) this;
        }

        public Criteria andMarketListIdIsNotNull() {
            addCriterion("a.market_list_id is not null");
            return (Criteria) this;
        }

        public Criteria andMarketListIdEqualTo(Integer value) {
            addCriterion("a.market_list_id =", value, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdNotEqualTo(Integer value) {
            addCriterion("a.market_list_id <>", value, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdGreaterThan(Integer value) {
            addCriterion("a.market_list_id >", value, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("a.market_list_id >=", value, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdLessThan(Integer value) {
            addCriterion("a.market_list_id <", value, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdLessThanOrEqualTo(Integer value) {
            addCriterion("a.market_list_id <=", value, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdIn(List<Integer> values) {
            addCriterion("a.market_list_id in", values, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdNotIn(List<Integer> values) {
            addCriterion("a.market_list_id not in", values, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdBetween(Integer value1, Integer value2) {
            addCriterion("a.market_list_id between", value1, value2, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketListIdNotBetween(Integer value1, Integer value2) {
            addCriterion("a.market_list_id not between", value1, value2, "marketListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdIsNull() {
            addCriterion("a.market_area_list_id is null");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdIsNotNull() {
            addCriterion("a.market_area_list_id is not null");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdEqualTo(Integer value) {
            addCriterion("a.market_area_list_id =", value, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdNotEqualTo(Integer value) {
            addCriterion("a.market_area_list_id <>", value, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdGreaterThan(Integer value) {
            addCriterion("a.market_area_list_id >", value, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("a.market_area_list_id >=", value, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdLessThan(Integer value) {
            addCriterion("a.market_area_list_id <", value, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdLessThanOrEqualTo(Integer value) {
            addCriterion("a.market_area_list_id <=", value, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdIn(List<Integer> values) {
            addCriterion("a.market_area_list_id in", values, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdNotIn(List<Integer> values) {
            addCriterion("a.market_area_list_id not in", values, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdBetween(Integer value1, Integer value2) {
            addCriterion("a.market_area_list_id between", value1, value2, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andMarketAreaListIdNotBetween(Integer value1, Integer value2) {
            addCriterion("a.market_area_list_id not between", value1, value2, "marketAreaListId");
            return (Criteria) this;
        }

        public Criteria andShopStatusIsNull() {
            addCriterion("a.shop_status is null");
            return (Criteria) this;
        }

        public Criteria andShopStatusIsNotNull() {
            addCriterion("a.shop_status is not null");
            return (Criteria) this;
        }

        public Criteria andShopStatusEqualTo(Integer value) {
            addCriterion("a.shop_status =", value, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andShopStatusNotEqualTo(Integer value) {
            addCriterion("a.shop_status <>", value, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andShopStatusGreaterThan(Integer value) {
            addCriterion("a.shop_status >", value, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andShopStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("a.shop_status >=", value, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andShopStatusLessThan(Integer value) {
            addCriterion("a.shop_status <", value, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andShopStatusLessThanOrEqualTo(Integer value) {
            addCriterion("a.shop_status <=", value, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andShopStatusIn(List<Integer> values) {
            addCriterion("a.shop_status in", values, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andShopStatusNotIn(List<Integer> values) {
            addCriterion("a.shop_status not in", values, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andShopStatusBetween(Integer value1, Integer value2) {
            addCriterion("a.shop_status between", value1, value2, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andShopStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("a.shop_status not between", value1, value2, "shopStatus");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("a.user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("a.user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("a.user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("a.user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("a.user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("a.user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("a.user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("a.user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("a.user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("a.user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("a.user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("a.user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("a.remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("a.remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("a.remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("a.remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("a.remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("a.remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("a.remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("a.remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("a.remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("a.remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("a.remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("a.remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("a.remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("a.remark not between", value1, value2, "remark");
            return (Criteria) this;
        }
        public Criteria andLngIsNull() {
            addCriterion("a.lng is null");
            return (Criteria) this;
        }

        public Criteria andLngIsNotNull() {
            addCriterion("a.lng is not null");
            return (Criteria) this;
        }

        public Criteria andLngEqualTo(Double value) {
            addCriterion("a.lng =", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngNotEqualTo(Double value) {
            addCriterion("a.lng <>", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngGreaterThan(Double value) {
            addCriterion("a.lng >", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngGreaterThanOrEqualTo(Double value) {
            addCriterion("a.lng >=", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngLessThan(Double value) {
            addCriterion("a.lng <", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngLessThanOrEqualTo(Double value) {
            addCriterion("a.lng <=", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngIn(List<Double> values) {
            addCriterion("a.lng in", values, "lng");
            return (Criteria) this;
        }

        public Criteria andLngNotIn(List<Double> values) {
            addCriterion("a.lng not in", values, "lng");
            return (Criteria) this;
        }

        public Criteria andLngBetween(Double value1, Double value2) {
            addCriterion("a.lng between", value1, value2, "lng");
            return (Criteria) this;
        }

        public Criteria andLngNotBetween(Double value1, Double value2) {
            addCriterion("a.lng not between", value1, value2, "lng");
            return (Criteria) this;
        }

        public Criteria andLatIsNull() {
            addCriterion("a.lat is null");
            return (Criteria) this;
        }

        public Criteria andLatIsNotNull() {
            addCriterion("a.lat is not null");
            return (Criteria) this;
        }

        public Criteria andLatEqualTo(Double value) {
            addCriterion("a.lat =", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatNotEqualTo(Double value) {
            addCriterion("a.lat <>", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatGreaterThan(Double value) {
            addCriterion("a.lat >", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatGreaterThanOrEqualTo(Double value) {
            addCriterion("a.lat >=", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatLessThan(Double value) {
            addCriterion("a.lat <", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatLessThanOrEqualTo(Double value) {
            addCriterion("a.lat <=", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatIn(List<Double> values) {
            addCriterion("a.lat in", values, "lat");
            return (Criteria) this;
        }

        public Criteria andLatNotIn(List<Double> values) {
            addCriterion("a.lat not in", values, "lat");
            return (Criteria) this;
        }

        public Criteria andLatBetween(Double value1, Double value2) {
            addCriterion("a.lat between", value1, value2, "lat");
            return (Criteria) this;
        }

        public Criteria andLatNotBetween(Double value1, Double value2) {
            addCriterion("a.lat not between", value1, value2, "lat");
            return (Criteria) this;
        }

        public Criteria andGeoCodeIsNull() {
            addCriterion("a.geo_code is null");
            return (Criteria) this;
        }

        public Criteria andGeoCodeIsNotNull() {
            addCriterion("a.geo_code is not null");
            return (Criteria) this;
        }

        public Criteria andGeoCodeEqualTo(Long value) {
            addCriterion("a.geo_code =", value, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeNotEqualTo(Long value) {
            addCriterion("a.geo_code <>", value, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeGreaterThan(Long value) {
            addCriterion("a.geo_code >", value, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeGreaterThanOrEqualTo(Long value) {
            addCriterion("a.geo_code >=", value, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeLessThan(Long value) {
            addCriterion("a.geo_code <", value, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeLessThanOrEqualTo(Long value) {
            addCriterion("a.geo_code <=", value, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeLike(Long value) {
            addCriterion("a.geo_code like", value, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeNotLike(Long value) {
            addCriterion("a.geo_code not like", value, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeIn(List<Long> values) {
            addCriterion("a.geo_code in", values, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeNotIn(List<Long> values) {
            addCriterion("a.geo_code not in", values, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeBetween(Long value1, Long value2) {
            addCriterion("a.geo_code between", value1, value2, "geoCode");
            return (Criteria) this;
        }

        public Criteria andGeoCodeNotBetween(Long value1, Long value2) {
            addCriterion("a.geo_code not between", value1, value2, "geoCode");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria implements Serializable {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion implements Serializable {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}